-- @author lixiyong01
-- @date 2022.08.26
-- 监控每天新增对任务，然后在看板中显示

use hdp_lbg_supin_zplisting;

CREATE TABLE hdp_lbg_supin_zplisting.app_zp_rock_task_online_monitor (
    `user_oa` string COMMENT '用户OA',
    `user_name` string COMMENT '用户姓名',
    `task_id` string COMMENT '任务ID',
    `task_name` string COMMENT '任务名称',
    `task_status` string COMMENT '任务状态',
    `create_time` string COMMENT '创建时间',
    `update_time` string COMMENT '更新时间'
) comment 'DP任务上线监控表'
PARTITIONED BY (dt string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY ','
STORED AS ORCFILE;
